{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["1 неделя","2 неделя"],"read":"whole","date_system":"1900"}

{"sheet":"1 неделя","index":0,"n_rows":100,"n_cols":5,"rows_kept":100,"merged":[[0,1,1,1],[0,2,1,2],[0,3,0,4],[2,0,2,4],[18,0,19,0],[23,0,23,4],[33,0,34,0],[39,0,39,4],[40,0,41,0],[54,0,54,4],[55,0,57,0],[63,0,64,0],[68,0,68,4],[70,0,73,0],[77,0,79,0],[83,0,83,4],[85,0,91,0],[92,0,94,0]]}
["1 неделя","Основные компоненты","Брутто"]
[{"$nulls":3},"Цена за кг","Сумма"]
["Понедельник"]
["салат из свежей  капусты ","капуста",99.6,25,{"$f":"C4*D4/1000","v":2.49}]
[null,"лук",12.5,30,{"v":0.375,"d":"0.38"}]
[null,"морковь",12.5,35,{"v":0.4375,"d":"0.44"}]
[null,"сахар",5,80,{"v":0.4,"d":"0.40"}]
[null,"масло растительное ",5,140,{"v":0.7,"d":"0.70"}]
["Биточки из говядины","Говядина (котлетное  мясо)",72,500,{"v":36,"d":"36.00"}]
[null,"Сухари",1,100,{"v":0.1,"d":"0.10"}]
[null,"Хлеб ржанойй",7,78,{"v":0.546,"d":"0.55"}]
[null,"Масло сливочное",5,900,{"v":4.5,"d":"4.50"}]
[null,"Соль",0.6,16,{"v":0.0096,"d":"0.01"}]
[null,"Масса п/ф",null,null,{"v":0,"d":"0.00"}]
[null,"Масло растительное",3,140,0.42]
["Каша гречневая","Крупа гречневая",50,100,{"v":5,"d":"5.00"}]
[null,"Масло сливочное",5,900,{"v":4.5,"d":"4.50"}]
[null,"Соль",0.5,16,{"v":0.008,"d":"0.01"}]
["Чай с сахаром","Чай",1,688,{"v":0.688,"d":"0.69"}]
[null,"Сахар",15,80,{"v":1.2,"d":"1.20"}]
["хлеб","Хлеб рж пшен",20,76,1.02]
["хлеб","хлеб пшеничный",30,78,{"$f":"C22*D22/1000","v":2.34}]
[null,"Итого",null,null,{"$f":"SUM(E4:E22)","v":{"v":60.73410000000001,"d":"60.73"}}]
["Вторник"]
["Фрукты","Яблоки",100,100,{"$f":"D25/1000*C25","v":{"v":10,"d":"10.00"}}]
["Рагу из птицы","курица",100,270,{"v":27,"d":"27.00"}]
[null,"картофель",63.7,25,{"v":1.5925000000000002,"d":"1.59"}]
[null,"соль",2,16,{"v":0.032,"d":"0.03"}]
[null,"морковь",28.4,35,{"v":0.994,"d":"0.99"}]
[null,"лук",14.3,30,{"v":0.429,"d":"0.43"}]
[null,"капуста ",69.8,25,{"v":1.745,"d":"1.75"}]
[null,"масло растительное ",4,140,0.56]
[null,"томат паста",2,175,0.35]
["Кофейный  напиток с молоком","Кофейный напиток",5,500,{"v":2.5,"d":"2.50"}]
[null,"Сахар",20,80,{"v":1.6,"d":"1.60"}]
[null,"Молоко",100,83,{"v":8.3,"d":"8.30"}]
["хлеб пшеничный ","хлеб",30,78,2.34]
["хлеб рж пшен","хлеб",20,76,1.52]
[null,"Итого",null,null,{"$f":"SUM(E25:E38)","v":{"v":58.96250000000001,"d":"58.96"}}]
["Среда"]
["Гуляш из говядины","Говядина",87,500,{"$f":"C41*D41/1000","v":{"v":43.5,"d":"43.50"}}]
[null,"Масло растительное",5,140,{"v":0.7,"d":"0.70"}]
[null,"Лук репчатый",18,30,0.54]
[null,"Томат паста",3.2,175,0.56]
[null,"Соль",1,16,{"v":0.016,"d":"0.02"}]
[null,"Мука",4,40,0.16]
["Макароны отварные","макароны",51,60,3.06]
[null,"Соль",3,16,{"v":0.048,"d":"0.05"}]
[null,"Масло слив",5,900,{"v":4.5,"d":"4.50"}]
["Чай с сахаром","Чай",1,688,6.88]
[null,"Сахар",15,80,{"$f":"C51*D51/1000","v":{"v":1.2,"d":"1.20"}}]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D52/1000*C52","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D53/1000*C53","v":1.52}]
[null,"Итого",null,null,{"$f":"SUM(E41:E53)","v":65.024}]
["Четверг"]
["Салат из моркови","Морковь",65,35,{"$f":"C56*D56/1000","v":{"v":2.275,"d":"2.28"}}]
[null,"Масло растительное",6,140,0.84]
[null,"Сахарный песок",6,80,0.48]
["Котлеты Рыбные","Котлеты рыбные п/ф из судака(трески)",100,325,{"v":32.5,"d":"32.50"}]
["Картофельное пюре","Картофель",170,25,4.25]
[null,"Молоко 2,5",24,83,{"v":1.992,"d":"1.99"}]
[null,"Масло слив",5.2,900,4.68]
[null,"Соль",1,16,{"v":0.016,"d":"0.02"}]
["Чай с сахаром","Заварка",1,688,{"v":0.688,"d":"0.69"}]
[null,"Сахар",15,80,{"v":1.2,"d":"1.20"}]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D66/1000*C66","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D67/1000*C67","v":1.52}]
[null,"Итого",null,null,{"$f":"SUM(E56:E67)","v":{"v":52.781,"d":"52.78"}}]
["Пятница"]
["Фрукты","Яблоки",100,{"v":100,"d":"100.00"},{"$f":"C70*D70/1000","v":{"v":10,"d":"10.00"}}]
["Котлеты рубленные из птицы","Котлета куриная",90,{"v":360,"d":"360.00"},{"v":32.4,"d":"32.40"}]
[null,"Сухари",8,100,{"v":0.8,"d":"0.80"}]
[null,"Масло сливоч",2,900,{"v":1.8,"d":"1.80"}]
[null,"Масло растительное",5,140,{"v":0.7,"d":"0.70"}]
["Рис отварной","рис",55,90,4.95]
[null,"масло сливочное ",7,900,{"v":6.3,"d":"6.30"}]
[null,"Соль",1,16,{"v":0.016,"d":"0.02"}]
["Чай с лимоном","заварка",1,688,{"v":0.688,"d":"0.69"}]
[null,"лимон",8,170,1.36]
[null,"Сахар",15,80,{"v":1.2,"d":"1.20"}]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D81/1000*C81","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D82/1000*C82","v":1.52}]
[null,"Итого",null,null,{"$f":"SUM(E70:E82)","v":{"v":64.074,"d":"64.07"}}]
["Суббота"]
["Фрукты","Апельсин",100,{"v":150,"d":"150.0"},{"$f":"D85*C85/1000","v":15}]
["Мясо тушеное","Говядина",83,{"v":500,"d":"500.0"},41.5]
[null,"Морковь",5,{"v":35,"d":"35.0"},0.175]
[null,"Лук",5,{"v":30,"d":"30.0"},0.15]
[null,"Масло рас",5,{"v":140,"d":"140.0"},0.7]
[null,"Томатная паста",7,{"v":175,"d":"175.0"},1.225]
[null,"Мука пшенич",2,{"v":40,"d":"40.0"},0.08]
[null,"соль",1,{"v":16,"d":"16.0"},0.016]
["Макароны отварные","Макаронные изделия",53,{"v":60,"d":"60.0"},3.18]
[null,"Масло сливочное",5,{"v":900,"d":"900.0"},4.5]
[null,"соль",1,{"v":16,"d":"16.0"},0.016]
["Чай с сахаром","Заварка",1,688,0.688]
[null,"Сахар",15,80,1.2]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D98/1000*C98","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D99/1000*C99","v":1.52}]
[null,"Итого",null,null,{"$f":"SUM(E85:E99)","v":{"v":72.29,"d":"72.3"}}]

{"sheet":"2 неделя","index":1,"n_rows":90,"n_cols":7,"rows_kept":90,"merged":[[0,1,1,1],[0,2,1,2],[0,3,0,4],[2,0,2,4],[3,0,4,0],[5,0,6,0],[13,0,13,4],[21,0,23,0],[27,0,27,4],[28,0,32,0],[45,0,45,4],[62,0,62,4],[63,0,68,0],[69,0,71,0],[77,0,77,4],[78,0,79,0]]}
["2 неделя","Основные компоненты","Брутто"]
[{"$nulls":3},"Цена за кг","Сумма"]
["Понедельник"]
["Сосиски говяжие","Сосиски гов",102,380,{"$f":"C4*D4/1000","v":38.76}]
[null,"Гречка",54,100,{"v":5.4,"d":"5.40"}]
["Каша гречневая","Слив масло",5,900,{"v":4.5,"d":"4.50"}]
[null,"соль ",1,16,{"v":0.016,"d":"0.02"}]
["Какао  с молоком","Какао",4,271,{"v":1.084,"d":"1.08"}]
[null,"Сахар",15,80,{"v":1.2,"d":"1.20"}]
[null,"Молоко",100,83,{"v":8.3,"d":"8.30"}]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D11/1000*C11","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D12/1000*C12","v":1.52}]
[null,"Итого",null,null,{"$f":"SUM(E4:E12)","v":{"v":63.12000000000001,"d":"63.12"}}]
["Вторник"]
["Плов из птицы","Курица",90,270,{"$f":"C15*D15/1000","v":{"v":24.3,"d":"24.30"}}]
[null,"масло рас",7,140,{"$f":"C16*D16/1000","v":0.98}]
[null,"лук",10,30,{"$f":"C17*D17/1000","v":{"v":0.3,"d":"0.30"}}]
[null,"морковь",15,35,{"v":0.525,"d":"0.53"}]
[null,"Томат паста",5,175,{"$f":"C19*D19/1000","v":{"v":0.875,"d":"0.88"}}]
[null,"рис",35,90,3.15]
[null,"соль",1,{"v":16,"d":"16.00"},{"v":0.016,"d":"0.02"}]
["Чай с сахаром с лимоном","Чай",1,688,{"v":0.688,"d":"0.69"}]
[null,"лимон",8,170,1.36]
[null,"Сахар",15,80,{"v":1.2,"d":"1.20"}]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D25/1000*C25","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D26/1000*C26","v":1.52}]
[null,"Итого ",null,null,{"$f":"SUM(E15:E26)","v":{"v":37.254,"d":"37.25"}}]
["Среда"]
["Салат из св капусты","капуста",60,25,{"$f":"C29*D29/1000","v":1.5}]
[null,"Морковь",8,{"v":25,"d":"25.00"},0.2]
[null,"сахарный песок",3,{"v":80,"d":"80.00"},0.24]
[null,"соль",1,{"v":16,"d":"16.00"},0.016]
[null,"Масло растительное",7,{"v":140,"d":"140.00"},0.98]
["Котлеты рыбные","котлеты рыбные",102,325,33.15]
[null,"Соль",2,16,0.032]
[null,"Масло растительное",2,140,0.28]
["картофельное пюре ","картофель ",170,25,4.25]
[null,"молоко ",24,83,1.992]
[null,"Соль",1,16,0.016]
[null,"Масло слив",5,900,4.5]
["Чай  с сахаром","Чай",1,688,0.688]
[null,"Сахар",15,80,1.2]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D43/1000*C43","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D44/1000*C44","v":1.52}]
[null,"Итого",null,null,{"$f":"SUM(E29:E44)","v":{"v":52.904,"d":"52.9"}}]
["Четверг"]
["Салат из моркови","морковь",65,20,{"$f":"C47*D47/1000","v":{"v":1.3,"d":"1.30"}}]
[null,"соль",0.5,16,{"v":0.008,"d":"0.01"}]
[null,"масло растительное ",10,140,{"v":1.4,"d":"1.40"}]
["Птица тушеная в соусе","курица",100,270,{"v":27,"d":"27.00"}]
[null,"Масло растительное",2,140,0.28]
[null,"Мука пшеничная",4,40,0.16]
[null,"Соль",1,16,{"v":0.016,"d":"0.02"}]
[null,"сметана",{"v":12.5,"d":"13"},210,{"v":2.625,"d":"2.63"}]
["Макароны отварные","Макаронные изд",53,60,3.18]
[null,"Масло сливочное",5,900,{"v":4.5,"d":"4.50"}]
[null,"Соль",1,16,{"v":0.016,"d":"0.02"}]
["Кофейный напиток с молоком","кофейный напиток",5,500,{"v":2.5,"d":"2.50"}]
[null,"Сахар",20,80,{"v":1.6,"d":"1.60"}]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D60/1000*C60","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D61/1000*C61","v":1.52}]
[null,"Итого",null,null,{"$f":"SUM(E47:E61)","v":{"v":48.445,"d":"48.4"}}]
["Пятница"]
["Запеканка картофельная с мясом","говядина котлетное мясо",63,500,{"$f":"C64*D64/1000","v":{"v":31.5,"d":"31.50"}}]
[null,"Масло растительное",5,140,{"v":0.7,"d":"0.70"}]
[null,"Картофель",230,25,5.75]
[null,"лук",15,30,0.45]
[null,"масло сливочное ",11,900,{"v":9.9,"d":"9.90"}]
[null,"Соль",1,16,{"v":0.016,"d":"0.02"}]
["Чай с лимоном","заварка",1,688,{"v":0.688,"d":"0.69"}]
[null,"сахар",15,80,{"v":1.2,"d":"1.20"}]
[null,"лимон",8,170,1.36]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D73/1000*C73","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D74/1000*C74","v":1.52}]
["Масло слив.","масло сливочное ",10,900,{"$f":"C75*D75/1000","v":{"v":9,"d":"9.00"}}]
["Сыр","Сыр гол.",10,610,{"$f":"C76*D76/1000","v":{"v":6.1,"d":"6.10"}}]
[null,"Итого",null,null,{"$f":"SUM(E64:E76)","v":{"v":70.524,"d":"70.52"}}]
["Суббота"]
["Запеканка рисовая с творогом","рис",24,90,{"$f":"C79*D79/1000","v":2.16}]
[null,"творог",20,322,6.44]
[null,"Яйцо",0.2,10,{"v":2E-3,"d":"0.00"}]
[null,"Сахар",7.5,80,{"v":0.6,"d":"0.60"}]
[null,"Масло слив",10,900,{"v":9,"d":"9.00"}]
[null,"сметана",5,210,1.05]
["Чай с сахаром","заварка",1,{"v":688,"d":"688.0"},{"$f":"C85*D85/1000","v":{"v":0.688,"d":"0.69"}}]
[null,"Сахар",15,{"v":80,"d":"80.0"},{"$f":"C86*D86/1000","v":{"v":1.2,"d":"1.20"}}]
["хлеб пшеничный ","хлеб",30,78,{"$f":"D87/1000*C87","v":2.34}]
["хлеб рж пшен","хлеб",20,76,{"$f":"D88/1000*C88","v":1.52}]
[null,"Итого",null,null,{"$f":"SUM(E79:E88)","v":{"v":25,"d":"25.00"}}]
["Всего за 2 недели",{"$nulls":3},{"$f":"'1 неделя'!E23+'1 неделя'!E39+'1 неделя'!E54+'1 неделя'!E68+'1 неделя'!E83+'1 неделя'!E100+'2 неделя'!E13+'2 неделя'!E27+'2 неделя'!E45+'2 неделя'!E62+'2 неделя'!E77+'2 неделя'!E89","v":{"v":671.1126000000002,"d":"671.11"}},null,"при норме 50,3 руб в день, сумма 603,6 руб + 29,52 руб за счет собственной продукции (овощи) = 633,12 руб"]